Data isn't sorted next time table viewed in datasheet due to wrong sort.
Cause:
The table was sorted in Datasheet view instead of with the 'Indexes' command in Design view.
Solution:
In Table Design view, select the 'View' menu and select 'Indexes' to set the sorting of data in a table.
1) If the Database window is not activated, activate the Database window.
2) Click the 'Tables' tab in the Database window.
Tables tab
3) Select the desired table from the list box. (The selected table is highlighted.)
4) Click 'Design'. (The selected table appears in Design view)
5) Select the 'View' menu and select 'Indexes'. (The Indexes dialog box appears.)
6) Click in the 'Field Name' box. (A down arrow appears.)
7) Click down arrow. (A drop-down list appears.)
8) Select the field name to be sorted in the 'Field Name' drop-down list.
9) Click in the 'Sort Order' box next to the selected field name. (A down arrow appears.)
10) Click down arrow. (A drop-down arrow appears.)
11) Do one of the following to select the desired sort method:
a) Select 'Ascending' from the 'Sort Order' drop-down list to sort in ascending order.
b) Select 'Descending' from the 'Sort Order' drop-down list to sort in descending order.
12) Repeat steps 6) through 11) for each additional field to sort.
13) Click on the 'X' in the upper right corner of the 'Indexes' window to close.
14) Select the 'File' menu and select 'Save' to save changes to the table.
15) Select the 'View' menu and select 'Datasheet' to view the data in sorted order.
